Adaptable Data Analyst skilled in recording, interpreting and analyzing data in a fast-paced environment. Advanced proficiency in all aspects of Excel. Experienced in preparing detailed documents and reports while managing complex internal and external data analysis responsibilities.
Core Qualifications :
Data and statistical analysis
MS Excel proficiency
Report generation
Time management
Project management
Interpersonal communication
Performed daily data queries and prepared reports on daily, weekly, monthly, and quarterly basis.
Used advanced Excel functions to generate spreadsheets and pivot tables.
Responsible to Circulate Business Reports includes Delinquency, Resolution, Normalization and roll backs in allocated portfolio to RRM Heads.
Perform Collections & Recovery Incentive Calculations on monthly basis to analyze multiple factors e.g. Total Resolution, Normalization, No of Accounts, No of Volume, Rollbacks, ACR & KPIs of assigned portfolio and also responsible for RCM & RRM incentive calculation on quarterly basis to analyze their performance on total GCLs against targets.
Develop validation process in excel to ensure accuracy in Incentive Calculation.
Analyze Collections & Recovery Performance and on monthly basis.
Responsible to Route KPI Indicator Dashboard on monthly basis to ensure completion of milestone assigned to Collections & Recovery staff.
Route RDA Campaign tracker to all RRM staff to check their lead processing status and also responsible for proper coordination with liabilities to ensure accuracy in Lead numbers and conversations.
Developed COVID-19 dashboard in Excel for Delinquent customers to proper analyze loss & gain on DPD & Volume on tough COVID-19 situations.
Designed automated report to trend and calculate monthly performance on which productivity per staff / shop manager will be evaluated.
Responsible to analyze performance for RRM Awards given on quarterly basis base on their performance.
Responsible for Preparation of CIU capacity plans based on Total Case Logins, Reloggings, Cases Approvals and present to Human Resource Department for fu
Responsible to Circulate Business Reports to multiple regions across Pakistan.
Data driven solutions and working on critical Initiatives, identify opportunities to drive data analytics solutions
Developed consistency across reports and meaningful dashboards and publish them
Automate validation process for 75 efficiency gain in incentive calculation, salary and rank.
Designed automated report to trend and calculate monthly performance.
Designed different modules in excel based on multiple criteria for monthly, quarterly, half yearly & yearly contests result.
Create Macros to automate reports by using MS Excel to reduce process of preparing multiple reports on daily basis.
Process large volumes of data into meaningful summaries and presentations using POWER BI & Pivot Tables.
Work as a member of the operational team to achieve the business goals and objectives.
Scheduling Reports to circulate pending business & branch business reports for difference regions.
Coordinate with multiple branches in different regions to resolve queries on daily basis.
Oil and Gas Exploration Industry
Adaptable Data Analyst skilled in recording, interpreting and analyzing data in a fast-paced environment. Advanced proficiency in all aspects of Excel. Experienced in preparing detailed documents and reports while managing complex internal and external data analysis responsibilities.
Exporting data to MS Excel for periodic and exception reporting: creating various types of graphs and summaries.
Attending regular team meetings and participating in project discussions
Parent Dealing
Phone Handling
Manage Admissions Database
Prepare and provide various types of Database to different departments as per requirement
Managing Teacher Assistant (TA) Project : Data Mining , Calculation of utilization , provide graphs and summaries as per requirement